package com.yourwork.common.jpa;

import javax.persistence.Table;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.yourwork.model.Spending;
@Repository
@Table(name="expense")
@Qualifier("expenseRepositoey")
public interface SpendingRepositoey extends JpaRepository<Spending, Integer> {
	@Query(value="select Sum(e.money) from Spending e")
	double querySumMoney();

}
